home *** CD-ROM | disk | FTP | other *** search
/ 17 Bit Software 5: The Fifth Dimension / 17 Bit - The Fifth Dimension (1995)(17 Bit Software)[!].iso / files / 3859.dms / 3859.adf / Examples / STRINGS.calc (.txt) < prev    next >
EasyCalc Spreadsheet file  |  1995-07-02  |  1KB  |  45 lines
  1. EASY30HED1
  2. #'EasyCalc 2.0 - Example Worksheet 1
  3. 'String Functions
  4. 'Function Example
  5. "Result
  6. '=@CHR(65)
  7.     =@CHR(65)
  8. '=@COMPARE("A","B")
  9. =@COMPARE("A","B")
  10. '=@FIND("FREDDIE","RED",1)
  11. =@FIND("FREDDIE","RED",1)
  12. '=@INSTR("FREDDIE","red")
  13. =@INSTR("FREDDIE","red")
  14. '=@LEFT("FRED",2)
  15. =@LEFT("FRED",2)
  16. '=@LENGTH("freddie")
  17. =@LENGTH("freddie")
  18. '=@LOWER("FREDDIE")
  19. =@LOWER("FREDDIE")
  20. '=@MID("freddie",2,3)
  21. =@MID("freddie",2,3)
  22. '=@PROPER("mr freddie jones")
  23. =@PROPER("mr freddie jones")
  24. '=@REPEAT("fred ",4)
  25. =@REPEAT("fred ",4)
  26. '=@RIGHT("fred",2)
  27. =@RIGHT("fred",2)
  28. '=@STR(56.7)
  29. =@STR(56.7)
  30. '=@VAL("56.7")
  31. =@VAL("56.7")
  32. '=@UPPER("freddie")
  33. =@UPPER("freddie")
  34. D'New for EasyCalc 2.0, you can now compare and add strings together:
  35. '="A" = "B"
  36. ="A" = "B"
  37. '="A" <> "B"
  38. ="A" <> "B"
  39. '="A" + "B"
  40. ="A"+"B"
  41. '="A" > "B"
  42. ="A" > "B"
  43. '="A" < "B"
  44. ="A" < "B"
  45.